Lotus notes database/SQL linked server

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: Lotus notes database/SQL linked server

Feedback Type: Problem

Product Area: Database

Technical Area: Error Message

Platform: Windows XP client

Release: 8.5

Reproducible: Always

I am brand new to Lotus Notes so please forgive and newbieisms.

I have been given an nsf file from a client and asked to import it into SQL Server 2005. I have installed Lotus Notes Client 8.5 and I can open their application. I have installed NotesSQL 8.0 and used the NotesSQL Authentication List Manager to add a user id file to the user list. I have added the path where the notes dlls are held to the PATH environment variable (can't remember why at this point). In user security in the Notes application, I have given my account a password and I have set up a system DSN using the Lotus NotesSQL Driver, the nsf file I was given and the username and password that appears in Notes (I have selected local for the Domino server).
There is no "test connection" option in this screen but I don't get any error either.

Have I missed anything out? The reason I ask is that when I create a linked server in SQL 2005 I get an error saying the "test connection to the linked server failed" but I can't figure out why.

Any help would be greatly appreciated.

Feedback number WEBB7Q3MBE created by ~James Bubveluverobu on 03/12/2009

Status: Open
Comments: